Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ItemID (FK)(PK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | Item(AS_ITM) |
StoreWarrantyDescriptionCode | A code to signify the type of warranty offered by the RETAIL STORE. This warranty normally supplements the warranty offered by the MANUFACTURER | LU_WRTY_STR_SRZ | DescriptionShort | VARCHAR(255) | |
ManufacturerWarrantyDescriptionCode | A code to denote the type of warranty offered on the SERIALIZED ITEM by the MANUFACTURER | LU_WRTY_MF_SRZ_ITM | DescriptionShort | VARCHAR(255) | |
ManufacturerSizeDescription | A code to signify the maufacturer's size reference. | DE_SZ_MF_SRZ_ITM | DescriptionShort | VARCHAR(255) | |
ModelYear | The year of release or production of the SERIALIZED ITEM | CY_MDL_SRZ_ITM | DateCalendarYear | char(4) | |
ModelNumber | The model reference for a specific SERIALIZED ITEM. | NM_NMB_SRZ_ITM | DescriptionShort | VARCHAR(255) | |
ManufacturerColorDescription | The code to signify the manufacturer's color shade. | DE_CLR_MF_SRZ_ITM | DescriptionShort | VARCHAR(255) | |